alter trigger Modosit on Kikolcsonozve
for delete
as 

declare @KolcsId int
set @KolcsId = (select kolcsonID from deleted)

declare @Datum date
set @Datum = GETDATE()

update Kolcsonzes set DatBe = @Datum where KikolcsID = @KolcsId